<cfparam name="vstring" default="0">

<cfquery name = "qverify" datasource="#request.dsn#">
UPDATE core_accounts
SET confirmed = 1
WHERE vstring = '#vstring#'
</cfquery>

<cfsavecontent variable="verified_msg">
	<cfinclude template = "#request.absolutepath#docs/includes/affiliate_verified.cfm">
</cfsavecontent>

<cfoutput>#verified_msg#</cfoutput>

